package com.woniu.springgoods.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniu.springgoods.entity.Goods;

import java.util.List;

/**
* @author QIQI
* @description 针对表【t_goods】的数据库操作Mapper
* @createDate 2023-01-05 12:21:22
* @Entity cn.woniu.ecommerceplatform.entity.Goods
*/
public interface GoodsMapper extends BaseMapper<Goods> {

    List<Goods> queryBygoodNameOrgoodCodeOrshelfStatus(String goodName, String goodCode, Integer shelfStatus);
    List<Goods> queryBygoodNameOrtypeId(String goodName,Integer typeId);
    Goods queryGoodById(Integer id);
    List<Goods> queryGoodByIds(List<Integer> ids);

    Integer UpdateShelfStatusByids(List<Integer> ids,Integer shelfStatus);

    List<Goods> queryPGByNameCodeShelfStatus(String goodName);
}




